Pandas Report

Dataset statistics

Number of variables	14
Number of observations	551
Missing cells	1
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	60.4 KiB
Average record size in memory	112.2 B

Variable types

Numeric	8
Categorical	6

Alerts

`name` has a high cardinality: 549 distinct values	High cardinality
`host_name` has a high cardinality: 395 distinct values	High cardinality
`neighbourhood` has a high cardinality: 71 distinct values	High cardinality
`last_review` has a high cardinality: 229 distinct values	High cardinality
`id` is highly overall correlated with `host_id`	High correlation
`host_id` is highly overall correlated with `id`	High correlation
`number_of_reviews` is highly overall correlated with `reviews_per_month`	High correlation
`reviews_per_month` is highly overall correlated with `number_of_reviews`	High correlation
`calculated_host_listings_count` is highly overall correlated with `neighbourhood`	High correlation
`neighbourhood_group` is highly overall correlated with `neighbourhood`	High correlation
`neighbourhood` is highly overall correlated with `calculated_host_listings_count` and 1 other fields	High correlation
`name` is uniformly distributed	Uniform
`host_name` is uniformly distributed	Uniform
`id` has unique values	Unique
`number_of_reviews` has 17 (3.1%) zeros	Zeros

Reproduction

Analysis started	2023-01-22 11:34:05.135103
Analysis finished	2023-01-22 11:34:26.898856
Duration	21.76 seconds
Software version	pandas-profiling vv3.6.2
Download configuration	config.json

id
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	551
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	83358.931

Minimum	2539
Maximum	204065
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.4 KiB

Quantile statistics

Minimum	2539
5-th percentile	9437.5
Q1	32008.5
median	65268
Q3	138920
95-th percentile	190027
Maximum	204065
Range	201526
Interquartile range (IQR)	106911.5

Descriptive statistics

Standard deviation	59539.3
Coefficient of variation (CV)	0.7142522
Kurtosis	-1.049293
Mean	83358.931
Median Absolute Deviation (MAD)	43624
Skewness	0.51628699
Sum	45930771
Variance	3.5449283 × 10⁹
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2539	1	0.2%
106647	1	0.2%
103161	1	0.2%
103311	1	0.2%
103806	1	0.2%
105469	1	0.2%
105510	1	0.2%
106363	1	0.2%
107630	1	0.2%
89427	1	0.2%
Other values (541)	541	98.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2539	1	0.2%
2595	1	0.2%
3647	1	0.2%
3831	1	0.2%
5022	1	0.2%
5099	1	0.2%
5121	1	0.2%
5178	1	0.2%
5203	1	0.2%
5238	1	0.2%

Value	Count	Frequency (%)
204065	1	0.2%
203901	1	0.2%
202273	1	0.2%
201992	1	0.2%
200955	1	0.2%
200645	1	0.2%
199312	1	0.2%
199195	1	0.2%
197942	1	0.2%
197753	1	0.2%

name
Categorical

HIGH CARDINALITY UNIFORM

Distinct	549
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Memory size	4.4 KiB

Loft w/ Terrace @ Box House Hotel	2
Superior @ Box House	2
Tree lined block modern apartment	1
2 BR w/ Terrace @ Box House Hotel	1
BOHEMIAN EAST VILLAGE 2 BED HAVEN	1
Other values (544)	544

Length

Max length	50
Median length	45
Mean length	33.818512
Min length	3

Characters and Unicode

Total characters	18634
Distinct characters	90
Distinct categories	13 ?
Distinct scripts	3 ?
Distinct blocks	5 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	547 ?
Unique (%)	99.3%

Sample

1st row	Clean & quiet apt home by the park
2nd row	Skylit Midtown Castle
3rd row	THE VILLAGE OF HARLEM....NEW YORK !
4th row	Cozy Entire Floor of Brownstone
5th row	Entire Apt: Spacious Studio/Loft by central park

Common Values

Value	Count	Frequency (%)
Loft w/ Terrace @ Box House Hotel	2	0.4%
Superior @ Box House	2	0.4%
Tree lined block modern apartment	1	0.2%
2 BR w/ Terrace @ Box House Hotel	1	0.2%
BOHEMIAN EAST VILLAGE 2 BED HAVEN	1	0.2%
Oceanfront Apartment in Rockaway	1	0.2%
Private 1-Bedroom Apt in Townhouse	1	0.2%
Bright Room With A Great River View	1	0.2%
Clean & quiet apt home by the park	1	0.2%
Artsy TopFloor Apt in PRIME BEDFORD Williamsburg	1	0.2%
Other values (539)	539	97.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
in	134	4.4%
	95	3.1%
apt	73	2.4%
room	70	2.3%
apartment	61	2.0%
private	57	1.9%
bedroom	54	1.8%
village	51	1.7%
cozy	49	1.6%
east	49	1.6%
Other values (695)	2364	77.3%

Most occurring characters

Value	Count	Frequency (%)
	2549	13.7%
e	1293	6.9%
o	1119	6.0%
t	1033	5.5%
a	1006	5.4%
r	956	5.1%
n	909	4.9%
i	872	4.7%
l	639	3.4%
s	482	2.6%
Other values (80)	7776	41.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	11744	63.0%
Uppercase Letter	3526	18.9%
Space Separator	2549	13.7%
Other Punctuation	434	2.3%
Decimal Number	238	1.3%
Dash Punctuation	88	0.5%
Math Symbol	18	0.1%
Open Punctuation	9	< 0.1%
Close Punctuation	9	< 0.1%
Other Symbol	9	< 0.1%
Other values (3)	10	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1293	11.0%
o	1119	9.5%
t	1033	8.8%
a	1006	8.6%
r	956	8.1%
n	909	7.7%
i	872	7.4%
l	639	5.4%
s	482	4.1%
u	455	3.9%
Other values (16)	2980	25.4%

Uppercase Letter

Value	Count	Frequency (%)
S	308	8.7%
B	307	8.7%
A	275	7.8%
C	250	7.1%
R	226	6.4%
L	216	6.1%
E	207	5.9%
T	163	4.6%
O	158	4.5%
N	158	4.5%
Other values (16)	1258	35.7%

Other Punctuation

Value	Count	Frequency (%)
,	108	24.9%
!	80	18.4%
/	68	15.7%
.	66	15.2%
&	42	9.7%
*	21	4.8%
'	18	4.1%
#	9	2.1%
:	8	1.8%
@	7	1.6%
Other values (3)	7	1.6%

Decimal Number

Value	Count	Frequency (%)
1	81	34.0%
2	72	30.3%
3	27	11.3%
5	21	8.8%
0	17	7.1%
4	10	4.2%
8	3	1.3%
7	3	1.3%
9	2	0.8%
6	2	0.8%

Math Symbol

Value	Count	Frequency (%)
+	14	77.8%
>	2	11.1%
=	1	5.6%
~	1	5.6%

Other Symbol

Value	Count	Frequency (%)
☆	6	66.7%
⚡	2	22.2%
⭐	1	11.1%

Dash Punctuation

Value	Count	Frequency (%)
-	85	96.6%
—	3	3.4%

Space Separator

Value	Count	Frequency (%)
	2549	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	9	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	9	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	7	100.0%

Final Punctuation

Value	Count	Frequency (%)
’	2	100.0%

Nonspacing Mark

Value	Count	Frequency (%)
️	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	15270	81.9%
Common	3363	18.0%
Inherited	1	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1293	8.5%
o	1119	7.3%
t	1033	6.8%
a	1006	6.6%
r	956	6.3%
n	909	6.0%
i	872	5.7%
l	639	4.2%
s	482	3.2%
u	455	3.0%
Other values (42)	6506	42.6%

Common

Value	Count	Frequency (%)
	2549	75.8%
,	108	3.2%
-	85	2.5%
1	81	2.4%
!	80	2.4%
2	72	2.1%
/	68	2.0%
.	66	2.0%
&	42	1.2%
3	27	0.8%
Other values (27)	185	5.5%

Inherited

Value	Count	Frequency (%)
️	1	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	18618	99.9%
Misc Symbols	8	< 0.1%
Punctuation	6	< 0.1%
None	1	< 0.1%
VS	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	2549	13.7%
e	1293	6.9%
o	1119	6.0%
t	1033	5.5%
a	1006	5.4%
r	956	5.1%
n	909	4.9%
i	872	4.7%
l	639	3.4%
s	482	2.6%
Other values (73)	7760	41.7%

Misc Symbols

Value	Count	Frequency (%)
☆	6	75.0%
⚡	2	25.0%

Punctuation

Value	Count	Frequency (%)
—	3	50.0%
’	2	33.3%
•	1	16.7%

None

Value	Count	Frequency (%)
⭐	1	100.0%

VS

Value	Count	Frequency (%)
️	1	100.0%

host_id
Real number (ℝ)

Distinct	472
Distinct (%)	85.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	362242.5

Minimum	2787
Maximum	6197784
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.4 KiB

Quantile statistics

Minimum	2787
5-th percentile	17778
Q1	87991
median	276291
Q3	572239.5
95-th percentile	909190
Maximum	6197784
Range	6194997
Interquartile range (IQR)	484248.5

Descriptive statistics

Standard deviation	409585.08
Coefficient of variation (CV)	1.1306931
Kurtosis	77.979214
Mean	362242.5
Median Absolute Deviation (MAD)	204277
Skewness	6.2506866
Sum	1.9959562 × 10⁸
Variance	1.6775993 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
417504	6	1.1%
204539	5	0.9%
256161	5	0.9%
72062	4	0.7%
303939	4	0.7%
22486	4	0.7%
209460	3	0.5%
322716	3	0.5%
126607	3	0.5%
54275	3	0.5%
Other values (462)	511	92.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2787	1	0.2%
2845	1	0.2%
4396	1	0.2%
4632	1	0.2%
4869	1	0.2%
7192	1	0.2%
7310	1	0.2%
7322	1	0.2%
7355	1	0.2%
7356	1	0.2%

Value	Count	Frequency (%)
6197784	1	0.2%
3088389	1	0.2%
2248897	1	0.2%
1856604	1	0.2%
1000477	1	0.2%
988350	1	0.2%
973438	1	0.2%
971075	1	0.2%
964482	1	0.2%
961342	1	0.2%

host_name
Categorical

HIGH CARDINALITY UNIFORM

Distinct	395
Distinct (%)	71.8%
Missing	1
Missing (%)	0.2%
Memory size	4.4 KiB

Mark	7
Jason	6
Daniel	6
The Box House Hotel	6
Jessica	5
Other values (390)	520

Length

Max length	23
Median length	19
Mean length	6.1527273
Min length	1

Characters and Unicode

Total characters	3384
Distinct characters	59
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	305 ?
Unique (%)	55.5%

Sample

1st row	John
2nd row	Jennifer
3rd row	Elisabeth
4th row	LisaRoxanne
5th row	Laura

Common Values

Value	Count	Frequency (%)
Mark	7	1.3%
Jason	6	1.1%
Daniel	6	1.1%
The Box House Hotel	6	1.1%
Jessica	5	0.9%
Jennifer	5	0.9%
Wayne	5	0.9%
Alex	5	0.9%
Sarah	4	0.7%
Lisel	4	0.7%
Other values (385)	497	90.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	14	2.2%
and	10	1.6%
mark	7	1.1%
daniel	6	0.9%
the	6	0.9%
box	6	0.9%
house	6	0.9%
hotel	6	0.9%
jason	6	0.9%
alex	5	0.8%
Other values (405)	560	88.6%

Most occurring characters

Value	Count	Frequency (%)
a	392	11.6%
e	347	10.3%
n	273	8.1%
i	263	7.8%
r	204	6.0%
l	187	5.5%
o	139	4.1%
s	130	3.8%
t	121	3.6%
h	95	2.8%
Other values (49)	1233	36.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2638	78.0%
Uppercase Letter	638	18.9%
Space Separator	82	2.4%
Other Punctuation	25	0.7%
Math Symbol	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	392	14.9%
e	347	13.2%
n	273	10.3%
i	263	10.0%
r	204	7.7%
l	187	7.1%
o	139	5.3%
s	130	4.9%
t	121	4.6%
h	95	3.6%
Other values (18)	487	18.5%

Uppercase Letter

Value	Count	Frequency (%)
A	64	10.0%
S	59	9.2%
J	55	8.6%
M	54	8.5%
L	52	8.2%
T	39	6.1%
D	37	5.8%
C	36	5.6%
E	32	5.0%
B	29	4.5%
Other values (13)	181	28.4%

Other Punctuation

Value	Count	Frequency (%)
&	15	60.0%
.	5	20.0%
"	2	8.0%
'	1	4.0%
,	1	4.0%
/	1	4.0%

Space Separator

Value	Count	Frequency (%)
	82	100.0%

Math Symbol

Value	Count	Frequency (%)
+	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3276	96.8%
Common	108	3.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	392	12.0%
e	347	10.6%
n	273	8.3%
i	263	8.0%
r	204	6.2%
l	187	5.7%
o	139	4.2%
s	130	4.0%
t	121	3.7%
h	95	2.9%
Other values (41)	1125	34.3%

Common

Value	Count	Frequency (%)
	82	75.9%
&	15	13.9%
.	5	4.6%
"	2	1.9%
'	1	0.9%
,	1	0.9%
+	1	0.9%
/	1	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3377	99.8%
None	7	0.2%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	392	11.6%
e	347	10.3%
n	273	8.1%
i	263	7.8%
r	204	6.0%
l	187	5.5%
o	139	4.1%
s	130	3.8%
t	121	3.6%
h	95	2.8%
Other values (46)	1226	36.3%

None

Value	Count	Frequency (%)
ú	3	42.9%
é	2	28.6%
í	2	28.6%

neighbourhood_group
Categorical

Distinct	5
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	4.4 KiB

Brooklyn	260
Manhattan	253
Queens	25
Bronx	8
Staten Island	5

Length

Max length	13
Median length	9
Mean length	8.3702359
Min length	5

Characters and Unicode

Total characters	4612
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Brooklyn
2nd row	Manhattan
3rd row	Manhattan
4th row	Brooklyn
5th row	Manhattan

Common Values

Value	Count	Frequency (%)
Brooklyn	260	47.2%
Manhattan	253	45.9%
Queens	25	4.5%
Bronx	8	1.5%
Staten Island	5	0.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
brooklyn	260	46.8%
manhattan	253	45.5%
queens	25	4.5%
bronx	8	1.4%
staten	5	0.9%
island	5	0.9%

Most occurring characters

Value	Count	Frequency (%)
n	809	17.5%
a	769	16.7%
o	528	11.4%
t	516	11.2%
r	268	5.8%
B	268	5.8%
l	265	5.7%
y	260	5.6%
k	260	5.6%
M	253	5.5%
Other values (10)	416	9.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4051	87.8%
Uppercase Letter	556	12.1%
Space Separator	5	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	809	20.0%
a	769	19.0%
o	528	13.0%
t	516	12.7%
r	268	6.6%
l	265	6.5%
y	260	6.4%
k	260	6.4%
h	253	6.2%
e	55	1.4%
Other values (4)	68	1.7%

Uppercase Letter

Value	Count	Frequency (%)
B	268	48.2%
M	253	45.5%
Q	25	4.5%
S	5	0.9%
I	5	0.9%

Space Separator

Value	Count	Frequency (%)
	5	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4607	99.9%
Common	5	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	809	17.6%
a	769	16.7%
o	528	11.5%
t	516	11.2%
r	268	5.8%
B	268	5.8%
l	265	5.8%
y	260	5.6%
k	260	5.6%
M	253	5.5%
Other values (9)	411	8.9%

Common

Value	Count	Frequency (%)
	5	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4612	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	809	17.5%
a	769	16.7%
o	528	11.4%
t	516	11.2%
r	268	5.8%
B	268	5.8%
l	265	5.7%
y	260	5.6%
k	260	5.6%
M	253	5.5%
Other values (10)	416	9.0%

neighbourhood
Categorical

HIGH CARDINALITY HIGH CORRELATION

Distinct	71
Distinct (%)	12.9%
Missing	0
Missing (%)	0.0%
Memory size	4.4 KiB

Williamsburg	63
East Village	48
Harlem	46
Bedford-Stuyvesant	40
Greenpoint	26
Other values (66)	328

Length

Max length	25
Median length	17
Mean length	11.800363
Min length	4

Characters and Unicode

Total characters	6502
Distinct characters	50
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	25 ?
Unique (%)	4.5%

Sample

1st row	Kensington
2nd row	Midtown
3rd row	Harlem
4th row	Clinton Hill
5th row	East Harlem

Common Values

Value	Count	Frequency (%)
Williamsburg	63	11.4%
East Village	48	8.7%
Harlem	46	8.3%
Bedford-Stuyvesant	40	7.3%
Greenpoint	26	4.7%
Upper West Side	25	4.5%
Park Slope	20	3.6%
Crown Heights	18	3.3%
Chelsea	18	3.3%
Hell's Kitchen	17	3.1%
Other values (61)	230	41.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
east	92	10.3%
village	65	7.3%
williamsburg	63	7.1%
harlem	59	6.6%
side	53	5.9%
heights	42	4.7%
bedford-stuyvesant	40	4.5%
upper	38	4.3%
west	37	4.1%
slope	30	3.4%
Other values (79)	374	41.9%

Most occurring characters

Value	Count	Frequency (%)
e	671	10.3%
l	508	7.8%
i	462	7.1%
a	435	6.7%
s	409	6.3%
t	407	6.3%
r	393	6.0%
	342	5.3%
o	280	4.3%
n	269	4.1%
Other values (40)	2326	35.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5153	79.3%
Uppercase Letter	945	14.5%
Space Separator	342	5.3%
Dash Punctuation	44	0.7%
Other Punctuation	18	0.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
H	146	15.4%
S	143	15.1%
W	112	11.9%
E	93	9.8%
V	65	6.9%
C	64	6.8%
B	63	6.7%
G	59	6.2%
U	40	4.2%
P	34	3.6%
Other values (14)	126	13.3%

Lowercase Letter

Value	Count	Frequency (%)
e	671	13.0%
l	508	9.9%
i	462	9.0%
a	435	8.4%
s	409	7.9%
t	407	7.9%
r	393	7.6%
o	280	5.4%
n	269	5.2%
g	196	3.8%
Other values (12)	1123	21.8%

Other Punctuation

Value	Count	Frequency (%)
'	17	94.4%
.	1	5.6%

Space Separator

Value	Count	Frequency (%)
	342	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	44	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6098	93.8%
Common	404	6.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	671	11.0%
l	508	8.3%
i	462	7.6%
a	435	7.1%
s	409	6.7%
t	407	6.7%
r	393	6.4%
o	280	4.6%
n	269	4.4%
g	196	3.2%
Other values (36)	2068	33.9%

Common

Value	Count	Frequency (%)
	342	84.7%
-	44	10.9%
'	17	4.2%
.	1	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6502	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	671	10.3%
l	508	7.8%
i	462	7.1%
a	435	6.7%
s	409	6.3%
t	407	6.3%
r	393	6.0%
	342	5.3%
o	280	4.3%
n	269	4.1%
Other values (40)	2326	35.8%

room_type
Categorical

Distinct	3
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	4.4 KiB

Entire home/apt	321
Private room	225
Shared room	5

Length

Max length	15
Median length	15
Mean length	13.738657
Min length	11

Characters and Unicode

Total characters	7570
Distinct characters	17
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Private room
2nd row	Entire home/apt
3rd row	Private room
4th row	Entire home/apt
5th row	Entire home/apt

Common Values

Value	Count	Frequency (%)
Entire home/apt	321	58.3%
Private room	225	40.8%
Shared room	5	0.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
entire	321	29.1%
home/apt	321	29.1%
room	230	20.9%
private	225	20.4%
shared	5	0.5%

Most occurring characters

Value	Count	Frequency (%)
e	872	11.5%
t	867	11.5%
o	781	10.3%
r	781	10.3%
a	551	7.3%
	551	7.3%
m	551	7.3%
i	546	7.2%
h	326	4.3%
p	321	4.2%
Other values (7)	1423	18.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6147	81.2%
Space Separator	551	7.3%
Uppercase Letter	551	7.3%
Other Punctuation	321	4.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	872	14.2%
t	867	14.1%
o	781	12.7%
r	781	12.7%
a	551	9.0%
m	551	9.0%
i	546	8.9%
h	326	5.3%
p	321	5.2%
n	321	5.2%
Other values (2)	230	3.7%

Uppercase Letter

Value	Count	Frequency (%)
E	321	58.3%
P	225	40.8%
S	5	0.9%

Space Separator

Value	Count	Frequency (%)
	551	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	321	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6698	88.5%
Common	872	11.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	872	13.0%
t	867	12.9%
o	781	11.7%
r	781	11.7%
a	551	8.2%
m	551	8.2%
i	546	8.2%
h	326	4.9%
p	321	4.8%
E	321	4.8%
Other values (5)	781	11.7%

Common

Value	Count	Frequency (%)
	551	63.2%
/	321	36.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7570	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	872	11.5%
t	867	11.5%
o	781	10.3%
r	781	10.3%
a	551	7.3%
	551	7.3%
m	551	7.3%
i	546	7.2%
h	326	4.3%
p	321	4.2%
Other values (7)	1423	18.8%

price
Real number (ℝ)

Distinct	103
Distinct (%)	18.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	120.79211

Minimum	33
Maximum	239
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.4 KiB

Quantile statistics

Minimum	33
5-th percentile	50.5
Q1	90
median	120.79
Q3	140.5
95-th percentile	200
Maximum	239
Range	206
Interquartile range (IQR)	50.5

Descriptive statistics

Standard deviation	43.817112
Coefficient of variation (CV)	0.36274814
Kurtosis	-0.13600929
Mean	120.79211
Median Absolute Deviation (MAD)	28.21
Skewness	0.38874247
Sum	66556.451
Variance	1919.9393
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
121.8139535	71	12.9%
120.79	54	9.8%
150	24	4.4%
200	15	2.7%
99	14	2.5%
120	14	2.5%
75	13	2.4%
125	13	2.4%
130	13	2.4%
80	12	2.2%
Other values (93)	308	55.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
33	1	0.2%
35	1	0.2%
36	2	0.4%
37	3	0.5%
39	2	0.4%
40	2	0.4%
42	3	0.5%
43	1	0.2%
44	2	0.4%
45	1	0.2%

Value	Count	Frequency (%)
239	1	0.2%
235	1	0.2%
230	1	0.2%
229	1	0.2%
228	1	0.2%
225	8	1.5%
220	1	0.2%
219	2	0.4%
215	2	0.4%
211	1	0.2%

minimum_nights
Real number (ℝ)

Distinct	35
Distinct (%)	6.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.9285517

Minimum	1
Maximum	200
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	7
95-th percentile	30
Maximum	200
Range	199
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	15.755246
Coefficient of variation (CV)	1.9871531
Kurtosis	69.016251
Mean	7.9285517
Median Absolute Deviation (MAD)	1
Skewness	6.9581576
Sum	4368.632
Variance	248.22779
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=35)

Value	Count	Frequency (%)
2	136	24.7%
3	115	20.9%
1	63	11.4%
4	50	9.1%
30	33	6.0%
5	33	6.0%
7	27	4.9%
7.928	19	3.4%
6	13	2.4%
14	11	2.0%
Other values (25)	51	9.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	63	11.4%
2	136	24.7%
3	115	20.9%
4	50	9.1%
5	33	6.0%
6	13	2.4%
7	27	4.9%
7.928	19	3.4%
8	3	0.5%
9	3	0.5%

Value	Count	Frequency (%)
200	1	0.2%
180	1	0.2%
90	3	0.5%
65	1	0.2%
60	1	0.2%
50	1	0.2%
45	3	0.5%
44	1	0.2%
40	1	0.2%
35	1	0.2%

number_of_reviews
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	171
Distinct (%)	31.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	70.034246

Minimum	0
Maximum	227
Zeros	17
Zeros (%)	3.1%
Negative	0
Negative (%)	0.0%
Memory size	4.4 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	22
median	66
Q3	94
95-th percentile	197.5
Maximum	227
Range	227
Interquartile range (IQR)	72

Descriptive statistics

Standard deviation	59.359421
Coefficient of variation (CV)	0.84757706
Kurtosis	0.13570718
Mean	70.034246
Median Absolute Deviation (MAD)	40
Skewness	0.98209929
Sum	38588.87
Variance	3523.5408
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
70.03426124	52	9.4%
70.034	32	5.8%
0	17	3.1%
1	10	1.8%
11	9	1.6%
9	9	1.6%
4	8	1.5%
10	8	1.5%
18	7	1.3%
2	7	1.3%
Other values (161)	392	71.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	17	3.1%
1	10	1.8%
2	7	1.3%
3	6	1.1%
4	8	1.5%
5	5	0.9%
6	4	0.7%
7	4	0.7%
8	6	1.1%
9	9	1.6%

Value	Count	Frequency (%)
227	4	0.7%
226	1	0.2%
225	1	0.2%
223	1	0.2%
222	2	0.4%
220	1	0.2%
219	1	0.2%
218	1	0.2%
214	2	0.4%
213	1	0.2%

last_review
Categorical

Distinct	229
Distinct (%)	41.6%
Missing	0
Missing (%)	0.0%
Memory size	4.4 KiB

7/1/2019	38
6/23/2019	26
6/24/2019	19
6/16/2019	15
6/22/2019	14
Other values (224)	439

Length

Max length	10
Median length	9
Mean length	8.7749546
Min length	8

Characters and Unicode

Total characters	4835
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	153 ?
Unique (%)	27.8%

Sample

1st row	10/19/2018
2nd row	5/21/2019
3rd row	7/1/2019
4th row	7/5/2019
5th row	11/19/2018

Common Values

Value	Count	Frequency (%)
7/1/2019	38	6.9%
6/23/2019	26	4.7%
6/24/2019	19	3.4%
6/16/2019	15	2.7%
6/22/2019	14	2.5%
6/30/2019	11	2.0%
6/20/2019	11	2.0%
6/29/2019	10	1.8%
6/26/2019	9	1.6%
6/28/2019	8	1.5%
Other values (219)	390	70.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
7/1/2019	38	6.9%
6/23/2019	26	4.7%
6/24/2019	19	3.4%
6/16/2019	15	2.7%
6/22/2019	14	2.5%
6/30/2019	11	2.0%
6/20/2019	11	2.0%
6/29/2019	10	1.8%
6/26/2019	9	1.6%
6/28/2019	8	1.5%
Other values (219)	390	70.8%

Most occurring characters

Value	Count	Frequency (%)
/	1102	22.8%
1	896	18.5%
2	834	17.2%
0	629	13.0%
9	449	9.3%
6	305	6.3%
7	170	3.5%
5	135	2.8%
8	125	2.6%
3	115	2.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3733	77.2%
Other Punctuation	1102	22.8%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	896	24.0%
2	834	22.3%
0	629	16.8%
9	449	12.0%
6	305	8.2%
7	170	4.6%
5	135	3.6%
8	125	3.3%
3	115	3.1%
4	75	2.0%

Other Punctuation

Value	Count	Frequency (%)
/	1102	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	4835	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
/	1102	22.8%
1	896	18.5%
2	834	17.2%
0	629	13.0%
9	449	9.3%
6	305	6.3%
7	170	3.5%
5	135	2.8%
8	125	2.6%
3	115	2.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4835	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
/	1102	22.8%
1	896	18.5%
2	834	17.2%
0	629	13.0%
9	449	9.3%
6	305	6.3%
7	170	3.5%
5	135	2.8%
8	125	2.6%
3	115	2.4%

reviews_per_month
Real number (ℝ)

Distinct	227
Distinct (%)	41.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.0487151

Minimum	0.01
Maximum	6.7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.4 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.06
Q1	0.3
median	0.8
Q3	1.435
95-th percentile	3.015
Maximum	6.7
Range	6.69
Interquartile range (IQR)	1.135

Descriptive statistics

Standard deviation	0.99990361
Coefficient of variation (CV)	0.95345595
Kurtosis	4.6275907
Mean	1.0487151
Median Absolute Deviation (MAD)	0.53
Skewness	1.8022455
Sum	577.842
Variance	0.99980723
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.054	43	7.8%
0.11	9	1.6%
0.1	7	1.3%
0.03	7	1.3%
0.21	6	1.1%
0.22	6	1.1%
0.16	6	1.1%
0.08	6	1.1%
0.09	6	1.1%
0.38	6	1.1%
Other values (217)	449	81.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	4	0.7%
0.02	4	0.7%
0.03	7	1.3%
0.04	5	0.9%
0.05	5	0.9%
0.06	4	0.7%
0.07	5	0.9%
0.08	6	1.1%
0.09	6	1.1%
0.1	7	1.3%

Value	Count	Frequency (%)
6.7	1	0.2%
6.62	1	0.2%
4.72	1	0.2%
4.64	1	0.2%
4.58	1	0.2%
4.5	1	0.2%
4.44	1	0.2%
4.34	1	0.2%
4.22	1	0.2%
4.1	1	0.2%

calculated_host_listings_count
Real number (ℝ)

Distinct	12
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.0509074

Minimum	1
Maximum	28
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	5
Maximum	28
Range	27
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	3.0583937
Coefficient of variation (CV)	1.4912393
Kurtosis	54.742189
Mean	2.0509074
Median Absolute Deviation (MAD)	0
Skewness	6.9107659
Sum	1130.05
Variance	9.3537719
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	341	61.9%
2	106	19.2%
3	48	8.7%
4	17	3.1%
5	14	2.5%
6	13	2.4%
28	6	1.1%
8	2	0.4%
2.05	1	0.2%
7	1	0.2%
Other values (2)	2	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	341	61.9%
2	106	19.2%
2.05	1	0.2%
3	48	8.7%
4	17	3.1%
5	14	2.5%
6	13	2.4%
7	1	0.2%
8	2	0.4%
11	1	0.2%

Value	Count	Frequency (%)
28	6	1.1%
13	1	0.2%
11	1	0.2%
8	2	0.4%
7	1	0.2%
6	13	2.4%
5	14	2.5%
4	17	3.1%
3	48	8.7%
2.05	1	0.2%

availability_365
Real number (ℝ)

Distinct	205
Distinct (%)	37.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	212.51361

Minimum	1
Maximum	365
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.4 KiB

Quantile statistics

Minimum	1
5-th percentile	8.5
Q1	66
median	246
Q3	346
95-th percentile	365
Maximum	365
Range	364
Interquartile range (IQR)	280

Descriptive statistics

Standard deviation	132.98335
Coefficient of variation (CV)	0.6257639
Kurtosis	-1.4146678
Mean	212.51361
Median Absolute Deviation (MAD)	119
Skewness	-0.34015513
Sum	117095
Variance	17684.57
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
365	109	19.8%
189	8	1.5%
188	7	1.3%
6	7	1.3%
34	7	1.3%
12	6	1.1%
2	6	1.1%
364	6	1.1%
3	5	0.9%
31	5	0.9%
Other values (195)	385	69.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4	0.7%
2	6	1.1%
3	5	0.9%
5	1	0.2%
6	7	1.3%
7	3	0.5%
8	2	0.4%
9	4	0.7%
11	1	0.2%
12	6	1.1%

Value	Count	Frequency (%)
365	109	19.8%
364	6	1.1%
363	2	0.4%
362	2	0.4%
361	1	0.2%
359	4	0.7%
358	1	0.2%
355	4	0.7%
353	3	0.5%
351	1	0.2%

Auto

Heatmap
Table

	id	host_id	price	minimum_nights	number_of_reviews	reviews_per_month	calculated_host_listings_count	availability_365	neighbourhood_group	neighbourhood	room_type
id	1.000	0.826	0.024	0.043	-0.062	-0.038	-0.032	0.052	0.090	0.092	0.071
host_id	0.826	1.000	0.044	0.070	-0.098	-0.050	-0.139	0.048	0.000	0.000	0.000
price	0.024	0.044	1.000	0.126	-0.108	-0.150	-0.227	-0.050	0.179	0.169	0.430
minimum_nights	0.043	0.070	0.126	1.000	-0.273	-0.300	-0.149	-0.003	0.000	0.000	0.000
number_of_reviews	-0.062	-0.098	-0.108	-0.273	1.000	0.736	0.156	-0.194	0.121	0.005	0.025
reviews_per_month	-0.038	-0.050	-0.150	-0.300	0.736	1.000	0.115	-0.115	0.114	0.000	0.064
calculated_host_listings_count	-0.032	-0.139	-0.227	-0.149	0.156	0.115	1.000	0.019	0.264	0.533	0.107
availability_365	0.052	0.048	-0.050	-0.003	-0.194	-0.115	0.019	1.000	0.039	0.120	0.042
neighbourhood_group	0.090	0.000	0.179	0.000	0.121	0.114	0.264	0.039	1.000	0.938	0.081
neighbourhood	0.092	0.000	0.169	0.000	0.005	0.000	0.533	0.120	0.938	1.000	0.127
room_type	0.071	0.000	0.430	0.000	0.025	0.064	0.107	0.042	0.081	0.127	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
0	2539	Clean & quiet apt home by the park	2787	John	Brooklyn	Kensington	Private room	149.00	1.0	9.000000	10/19/2018	0.210	6.00	365
1	2595	Skylit Midtown Castle	2845	Jennifer	Manhattan	Midtown	Entire home/apt	225.00	1.0	45.000000	5/21/2019	0.380	2.00	355
2	3647	THE VILLAGE OF HARLEM....NEW YORK !	4632	Elisabeth	Manhattan	Harlem	Private room	150.00	3.0	0.000000	7/1/2019	1.054	1.00	365
3	3831	Cozy Entire Floor of Brownstone	4869	LisaRoxanne	Brooklyn	Clinton Hill	Entire home/apt	89.00	1.0	70.034261	7/5/2019	4.640	1.00	194
4	5022	Entire Apt: Spacious Studio/Loft by central park	7192	Laura	Manhattan	East Harlem	Entire home/apt	80.00	10.0	9.000000	11/19/2018	0.100	2.05	365
5	5099	Large Cozy 1 BR Apartment In Midtown East	7322	Chris	Manhattan	Murray Hill	Entire home/apt	200.00	3.0	74.000000	6/22/2019	0.590	1.00	129
6	5121	BlissArtsSpace!	7356	Garon	Brooklyn	Bedford-Stuyvesant	Private room	60.00	45.0	49.000000	10/5/2017	0.400	1.00	365
7	5178	Large Furnished Room Near B'way	8967	Shunichi	Manhattan	Hell's Kitchen	Private room	120.79	2.0	70.034261	10/6/2017	3.470	1.00	22
8	5203	Cozy Clean Guest Room - Family Apt	7490	MaryEllen	Manhattan	Upper West Side	Private room	120.79	2.0	118.000000	10/7/2017	0.990	1.00	365
9	5238	Cute & Cozy Lower East Side 1 bdrm	7549	Ben	Manhattan	Chinatown	Entire home/apt	150.00	1.0	160.000000	10/8/2017	1.330	4.00	188

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
541	197753	Large room in elevator drman bldg	964482	Colin	Manhattan	Harlem	Private room	68.000000	2.0	70.034	6/12/2019	3.900	2.0	188
542	197942	Comfy, Cozy, Brooklyn close to Manhattan	289135	Toni	Brooklyn	Bedford-Stuyvesant	Entire home/apt	99.000000	3.0	70.034	7/7/2019	2.180	1.0	34
543	199195	Modern Bedroom in Hamilton Heights	971075	Jabari	Manhattan	Harlem	Private room	75.000000	3.0	50.000	3/30/2019	0.650	2.0	38
544	199312	Sunny Space in Williamsburg	973438	Susanne	Brooklyn	Williamsburg	Private room	100.000000	2.0	70.034	6/24/2019	2.850	1.0	254
545	200645	Best Manhattan Studio Deal!	933378	Edo	Manhattan	Upper East Side	Shared room	90.000000	1.0	70.034	7/1/2019	1.054	1.0	365
546	200955	STYLISH EAST VILLAGE FLAT	568325	Simone	Manhattan	East Village	Entire home/apt	160.000000	30.0	25.000	4/30/2018	0.260	1.0	46
547	201992	Serene Park Slope Garden Apartment	988350	Andrea	Brooklyn	Park Slope	Entire home/apt	190.000000	4.0	105.000	5/11/2019	1.620	1.0	328
548	202273	Cozy and spacious - rare for NYC!	918087	Kestrel	Brooklyn	Bedford-Stuyvesant	Private room	67.000000	4.0	72.000	12/26/2016	0.760	3.0	365
549	203901	Beautiful UES apartment	1000477	Elizabeth	Manhattan	Upper East Side	Entire home/apt	190.000000	1.0	8.000	9/18/2016	0.080	1.0	365
550	204065	St. James Pl Garden Studio 1block to PRATT &Gtrain	51038	Erica	Brooklyn	Clinton Hill	Entire home/apt	121.813953	2.0	58.000	6/4/2019	0.610	6.0	199

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Decimal Number

Math Symbol

Other Symbol

Dash Punctuation

Space Separator

Open Punctuation

Close Punctuation

Currency Symbol

Final Punctuation

Nonspacing Mark

Most occurring scripts

Most frequent character per script

Latin

Common

Inherited

Most occurring blocks

Most frequent character per block

ASCII

Misc Symbols

Punctuation

None

VS

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Math Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common